#
# Ľṹ `shop_jilu`
#

CREATE TABLE `shop_jilu` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `classid` int(11) NOT NULL default '0',
  `pingpai` varchar(50) default NULL,
  `shichang` float default NULL,
  `youhui` float NOT NULL default '0',
  `shuoming` varchar(200) default NULL,
  `xingxi` text,
  `addtime` varchar(20) NOT NULL default '',
  `tuijian` int(1) NOT NULL default '0',
  `dianji` int(11) default '0',
  `img` varchar(100) default NULL,
  `bigimg` varchar(50) default NULL,
  `u_name` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) TYPE=MyISAM AUTO_INCREMENT=20 ;



#
# е `sp_jilu`
#

#
# Ľṹ `sp_lei`
#

CREATE TABLE `sp_lei` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `class` varchar(30) NOT NULL default '',
  `img` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Ľṹ `shop_new`
#

CREATE TABLE `shop_new` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `addtime` varchar(20) NOT NULL default '',
  `body` longtext,
  `u_name` varchar(50) default NULL,
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;


#
# Ľṹ `zz_user`
#

CREATE TABLE `zz_user` (
  `userid` int(11) NOT NULL auto_increment,
  `username` varchar(16) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `dizhi` varchar(30) default '0',
  `zhuye` varchar(30) default NULL,
  `email` varchar(50) default NULL,
  `oicq` int(20) unsigned default NULL,
  `aim` int(20) default NULL,
  `msn` varchar(30) default NULL,
  `qian` varchar(100) default NULL,
  `addtime` varchar(20) default NULL,
  `dengji` int(10) NOT NULL default '0',
  `posts` int(11) NOT NULL default '0',
  `email1` varchar(50) default NULL,
  `tell` varchar(40) default NULL,
  PRIMARY KEY  (`userid`),
  KEY `userid` (`userid`)
) TYPE=MyISAM AUTO_INCREMENT=37 ;

